﻿CREATE TABLE [dbo].[Folder_File] (
    [FolderID] UNIQUEIDENTIFIER NOT NULL,
    [FileID]   UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_Folder_File] PRIMARY KEY CLUSTERED ([FolderID] ASC, [FileID] ASC),
    CONSTRAINT [FK_Folder_File_File] FOREIGN KEY ([FileID]) REFERENCES [dbo].[File] ([FileID]),
    CONSTRAINT [FK_Folder_File_Folder] FOREIGN KEY ([FolderID]) REFERENCES [dbo].[Folder] ([FolderID])
);

